begin;
--
-- Data for Name: sys_company_preferences; Type: TABLE DATA; Schema: _100351;
--

COPY sys_master_user (user_id, login_name, access_code) FROM stdin;
1	vijayan	bGxpbmsxMjM=
1001	venkat	bGxpbmsxMjM=
\.

-- Data for Name: sys_master_user_type; Type: TABLE DATA; Schema: _100351;


COPY sys_master_preferences (preference_id, preference_desc, default_values)
FROM stdin;
2	{validate_order_ref}	yes
3	{validate_dc_no}	yes
4	{issue_from_stock}	yes
5	{include_location}	no
6	{show_desc}	yes
7	{show_address}	no
8	{split_group}	no
9	{material_issue_no_of_items}	15
10	{details_entry_no_of_items}	10
11	{valid_date_range}	2005-01-01~2006-01-01
12	{colour_scheme}	classic
\.

-- Data for Name: sys_master_privilege; Type: TABLE DATA; Schema: _100351;



COPY sys_master_privilege (privilege_id, module_id, data_category_desc) FROM
stdin;
1	sal	{commercial}
2	sal	{financial}
3	sal	{product}
4	sal	{internal}
5	pur	{commercial}
6	pur	{financial}
7	pur	{product}
8	pur	{internal}
9	prd	{commercial}
10	prd	{financial}
11	prd	{product}
12	prd	{internal}
13	stk	{commercial}
14	stk	{financial}
15	stk	{product}
16	stk	{internal}
17	sys	{commercial}
18	sys	{financial}
19	sys	{product}
20	sys	{internal}
21	acc	{commercial}
22	acc	{financial}
23	acc	{product}
24	acc	{internal}
25	gen	{commercial}
26	gen	{financial}
27	gen	{product}
28	gen	{internal}
\.

-- Data for Name: sys_master_relationship; Type: TABLE DATA; Schema: _100351;


-- COPY sys_master_relationship (relationship_id, partner_id, partner_code,
-- product_details_id, financial_details_id, commercial_details_id,
-- contact_details_id, payment_term_id, shipment_term_id, credit_days, agent_id,
-- agent_commission, zone_id, entered_by, entered_time, record_status) FROM
-- stdin;
-- 1	100350	\N	1	1	1	\N	\N	\N	\N
-- \N	\N	\N	\N	2005-02-07 15:17:30.712209	act
-- \.
-- 

-- Data for Name: sys_master_user_type; Type: TABLE DATA; Schema: _100351;



COPY sys_master_user_type (user_type_id, user_scope, user_type_desc) FROM stdin;
ceo	s	{"Master Account"}
prd	i	{Production}
dmg	i	{"Information Manager"}
dat	i	{"Data Entry"}
mkt	i	{Marketing}
pur	i	{Purchase}
buy	e	{Buyer}
sup	e	{Supplier}
ppt	e	{"Production Partner"}
agt	e	{Agent}
dwf	i	{"Data Entry (Non Financial)"}
\.


-- Data for Name: sys_user_info; Type: TABLE DATA; Schema: _100351; Owner:
-- leatherlink


COPY sys_user_info (user_id, user_type_id, relationship_id, first_name,
last_name, initials) FROM stdin;
1	ceo	1	\N	\N	\N
1001	dat	1	\N	\N	\N
\.


-- Data for Name: sys_master_company; Type: TABLE DATA; Schema: _100351; Owner:
-- leatherlink


COPY sys_master_company (company_id, company_name) FROM stdin;
100350	{"Venkat Shoes Pvt Ltd"}
\.

-- Data for Name: sys_company_product_details; Type: TABLE DATA; Schema:
-- _100351; 


COPY sys_company_product_details (product_details_id, relationship_id,
product_category_id, activity_id) FROM stdin;
1	1	120	sel
\.

-- Data for Name: sys_user_privilege; Type: TABLE DATA; Schema: _100351; Owner:
-- leatherlink*/


COPY sys_user_privilege (user_id, privilege_id, permission) FROM stdin;
1	1	rem
1	2	rem
1	3	rem
1	4	rem
1	5	rem
1	6	rem
1	7	rem
1	8	rem
1	9	rem
1	10	rem
1	11	rem
1	12	rem
1	13	rem
1	14	rem
1	15	rem
1	16	rem
1	17	rem
1	18	rem
1	19	rem
1	20	rem
1	21	rem
1	22	rem
1	23	rem
1	24	rem
1	25	rem
1	26	rem
1	27	rem
1	28	rem
1001	1	rem
1001	2	rem
1001	3	rem
1001	4	rem
1001	5	rem
1001	6	rem
1001	7	rem
1001	8	rem
1001	9	rem
1001	10	rem
1001	11	rem
1001	12	rem
1001	13	rem
1001	14	rem
1001	15	rem
1001	16	rem
1001	17	rem
1001	18	rem
1001	19	rem
1001	20	rem
1001	21	rem
1001	22	rem
1001	23	rem
1001	24	rem
1001	25	rem
1001	26	rem
1001	27	rem
1001	28	rem
\.

-- Data for Name: sys_company_preferences; Type: TABLE DATA; Schema: _100351;



COPY sys_company_preferences (preference_id, preferred_values) FROM stdin;
2	yes
3	yes
4	yes
6	yes
9	15
10	10
12	red
5	no
7	no
8	no
11	2005-01-01~2006-01-01
\.


COPY _mcity (city_id, city_code, city_name, state_id, country_id, area_code)
FROM stdin;
200113		Banglore		India	
200114		Jammu		India	
200115		Warangal		India	
200116		Chittoor		India	
200117		Ambur		India	
200118		Kanpur		India	
200119		Agra		India	
200120		Buenos Aires		Argentina	
200121		Dhaka		Bangladesh	
200122		Sydney		Australia	
200123		Arni		India	
200124		kalka ji		India	
200125		Mahim		India	
200126		Jaipur		India	
200127		Haryana		India	
200128		Punjab		India	
200129		Jalandhar		India	
200130		Ludhiana		India	
200131		Kanchepuram		India	
200658		Noombal	Tamil Nadu	India	
200659		Pallavaram	Tamil Nadu	India	
200070		Brussels		Belgium	
200660		Periamet	Tamil Nadu	India	
200956	 	fucecco			
200957	 	LE3 2BU			
200970	 	Pondicherry			
200971	 	Bangalore			
200978	 	Prato/			
200985	 	0			
200991	 	Guduvancheri			
201014	 	LUDHIANA			
201020	 	Gummidipoondi			
201029	 	Guduvanchei			
201045	 	Kanchipuram			
201051	 	Ghaziabad			
201073	 	Sukchar			
201764	0475	Kollam	Tamil Nadu	India	0475
200068		Brisbane		Australia	
200069		Vienna		Austria	
200071		Brasillia		Brazil	
200072		Rio de Janeiro		Brazil	
200073		Addis Ababa		Ethiopia	
200074		Paris		France	
200075		Genoa		Italy	
200076		Milan		Italy	
200077		Rome		Italy	
200078		Tokyo		Japan	
200079		Osaka		Japan	
200080		Seiul		South Africa	
200081		Klang		Malaysia	
200082		Kuala Lumpur		Malaysia	
200083		Santiago		Chile	
200084		Montreal		Canada	
200085		Ottawa		Canada	
200086		Toronto		Canada	
200087		Vancouver		Canada	
200088		Nicosia		Cyprus	
200089		Oslo		Norway	
200090		Lima		Peru	
200091		Warsaw		Poland	
200092		Bucharest		Romania	
200093		Kampala		Uganda	
200094		Caracas		Venezuela	
200095		Lusaka		Zambia	
200096		Hong Kong		Hong Kong	
200097		Frankfurt		Germany	
200098		Barcelona		Spain	
200099		Dallas		United States of America	
200100		Los Angeles		United States of America	
200101		Singapore		Singapore	
200102		Shanghai		China	
200103		Beijing		China	
200104		Guangzhou		China	
200105		Shenzhen		China	
200106		Taiwan		China	
200107		Chennai		India	
200108		Mumbai		India	
200109		New Delhi		India	
200110		Calcutta		India	
200111		Pondichery		India	
200112		Ranipet		India	
\.

COPY _mcountry (country_id, country_code, country_name, isd_code) FROM stdin;
200001		India	+91
200002		China	
200003		Hong Kong	
200004		United States of America	
200005		Germany	
200006		Thailand	
200007		Italy	
200008		United Kingdom	
200009		Japan	
200010		Malaysia	
200011		Singapore	
200012		Spain	
200013		Ethiopia	
200014		Philippines	
200015		Bangladesh	
200016		Belgium	
200017		Brazil	
200018		Egypt	
200019		France	
200020		Hungary	
200021		Indonesia	
200022		Ireland	
200023		Israel	
200024		Kenya	
200025		Antigua	
200026		Bahrain	
200027		Canada	
200028		Chile	
200029		Colombia	
200030		Cyprus	
200031		Czech Republic	
200032		Denmark	
200033		Finland	
200034		Iraq	
200035		Iran	
200036		Kuwait	
200037		Mexico	
200038		Morocco	
200039		NewZealand	
200040		Norway	
200041		Peru	
200042		Poland	
200043		Romania	
200044		Uganda	
200045		Uruguay	
200046		Macau	
200047		Myanmar	
200048		Netherlands	
200049		Nigeria	
200050		Pakistan	
200051		Portugal	
200052		Russia	
200053		Saudi Arabia	
200054		South Africa	
200055		South Korea	
200056		Sri Lanka	
200057		Switzerland	
200058		Taiwan	
200059		Tanzania	
200060		Turkey	
200061		Vietnam	
200062		Zimbabwe	
200063		Argentina	
200064		Australia	
200065		Austria	
200066		Venezuela	
200067		Zambia	
\.

COPY _mcurrency (currency_id, currency_code, currency_name) FROM stdin;
200133	UKP	Pound Sterling
200134	USD	U S Dollars
200135	INR	Indian Rupees
200136	EUR	Euro
\.

COPY _mship_mode (shipment_mode_id, shipment_mode_code, shipment_mode_name)
FROM
stdin;
200250	ar	air
200251	se	sea
200252	rd	road
200253	rl	rail
\.

COPY _100351._mcompany (company_id, company_code, company_name) FROM stdin;
200930	A.A	ADAM ASSOCIATES
200931	A.B.S.P.S.	A.B.S.POWER SYSTEM
201038	S.AG.	SUPREME AGENCIES
200932	A.E.	ACME ENTERPRISSES
200831	001	Splendid Leather Co
200832	002	Bachi Shoes
200368	003	Good Leather Company
200833	004	R.V. Enterprises
200834	005	Marvel Leather Company
200835	PKL	Presidency Kid Leather
200836	007	Hotter
200896	008	Hogl
200897	009	Gabor
200898	010	Florida
200899	011	Start Rite
200900	012	Primigi
200901	013	LG
200933	A.G.E.	A.G.ENTERPRISES
200934	A.I.	ASTRAL IMPEX
200935	A.N.	AIR NATIONAL
200936	A.P.L.	AUTOMARK PRIVATE LIMITED
200937	A.R.A.T.	A.R.ANWAR TRADERS
200938	A.T.S.	ATLAS TOOLS SUPPLIERS
200939	AC.	ACCESS
200940	AR F.	AR FABRICK
200941	B.A.	BABA AGENCIES
200942	B.E.	BHARATHI ELECTRICALS
200943	B.S.E.	BABA SAT-ELECTRONICS
200944	B.T.H.	BADHRUN TOOLS HARDWARE
200945	B.W.	BALAMUTHU WATCHES
200946	B.W.F.E.	BEST WELD FAB (HI-TECH)ENGINEERING
200947	C.A.	CRESCENT AGENCIES
200948	C.B.C	CHENNAI BRRAIDING COMPANY
200949	C.E.	CREST ENTERPRISES
200950	C.F.C.C.	CHEM-U-FIX CHEMICAL COMPANY
200951	C.G.	CROMPTON GREAVES
200952	C.I.	COATS INDIA]
200953	C.M.	CHENNAI METALS
200954	C.T.P.L	CHENNAI TAPES PRIVATE LIMITED
200955	CENTRO	centro machine per la scarpa
200958	E.D.L.	ELITE SHOES & LEATHERS
200959	E.E.E	ELECTRICALS ELECTRONICS ENTERPRISES
200960	E.L.P.L.	EURO LABELS PRIVATE LIMITED
200961	E.S.C.C.	EURO SHOE COMPONENTS & CO
200962	F.M.L	FAIRMOUNT MARKETING LTD
200963	G.H.	GENUINE HYDRAULICS
200964	G.I.S.M.	GOLDEN INDUSTRIAL SEWING MACHINE
200965	G.K.R.	G.K.ROOFINGS
200966	G.L.C	GOOD LEATHER COMPANY
200967	G.M.S.P.L.	GOVINDARAJU MUDALIAR SONS P LTD
200968	G.P.E.W.	G.PERUMAL ENGINEERING WORKS
200969	GTFC	GTFC - LIMITED TRADING DIVISION
200972	H.O.	HEAD OFFICE
200973	H.S.P.L.	HARMAN SALES PVT LTD
200974	H.T.F.	HI - TECH FOOT WEAR
200975	HA.S.P.L.	HARMAN SALES PVT. LTD.
200976	I.B.H.	INDUSTRIAL BEARINGS HOUSE
200977	I.B.S.P.A	INDUSTRIE BIAGIOLI S.P.A.
200979	I.G.E.	INDIAN GLASSWARE EMPORIUM
200980	I.R.C.	ISMAT RUBBER CORPORATION
200981	I.R.P.E.	INDIA RUBBER PLASTIC ENTERPRISES
200982	I.T.C.	INDIAN TRADING CORPORATION
201039	S.B.F.	SRI BALAJI FANCY
200984	K.C.C.	KAMARAJ CHEMICAL COTTAGE
200986	K.E.S.E.P.	K.E.S.ELECTRO PLATING
200987	K.M.	KASIM  MARKETING
200988	K.O.E.L.	KIRLOSKAR OIL ENGINES LTD.
200989	K.P.	KANNAN PROCESS
200990	K.R.L.	K.R.LAKSHMI
200992	L.I.	LAKSHMI INDUSTRIES
200993	L.L.C.P.L	LEATHER LEADER COMPANY (P) LIMITED
200994	L.L.S.	LIBERTY LEATHER STORES
200995	L.P.P.(P)L	LANTECH PERI PHERALS (P) LTD
200996	LI.A.	LIMRA ASSOCIATES
200997	M.A.E.	M.A.ETHIRAJULU NAIDU
200998	M.C.	METAL CRAFTS
200999	M.C.P.L.	MADURA COATS PRIVATE LIMITED
201000	M.E.	MAMTA ELECTRICALS
201001	M.ELE.	MAMTA ELECTRICALS & HARDWARES
201002	M.I.I	MAC-INDIA INTERNATIONAL
201003	M.L.C	MUTHU LEATHER CO.
201004	M.N.A.	M.NAFIZ AHAMED
201005	M.P.	MICRO PACK
201006	M.PA.	METRO PAPERS
201007	M.T.	MAHAVEER TRADERS
201008	M.T.C.	MACRO TRADING COMPANY
201040	S.B.V.E.	S.B.V.ENTERPRISES
201010	MA.T.	MADRAS TOOLS
201011	N.C.B.	NILKAMAL CRATES & BINS
201012	N.G.	N.GANDEEBAN
201013	N.L.	NAUYUG LAMINATION
201015	N.N.K.	N.NANDHA KUMAR
201016	O.A.	OSURI ASSOCIATES
201017	ONCE	ORIENT NETWORK CAARGO EXPRESS
201018	P A S	P A SHOES
201019	P.A.F.P.L.	P A FOOTWEAR PRIVATE LIMITED
201021	P.E.M.C.	PIONEER EYELETS MANF. CO.
201022	P.N.B.C.S.	P.N.BALU CHETTY SONS
201023	P.R.E.W	P.R.ENGINEERING WORKS
201041	S.C.P.L.	SRIRAGAV CARGO PVT. LTD.
201025	P.R.O.	P.R.OVERSEAS
201026	P.S.M.E.C.	PARIJATHAM SEWING MACHINE ENGINEER
201027	P.T.A.	PAMBAN TECHNO ASSOCIATES
201028	PKL	PRESIDENCY KID LEATHER LIMITED
201030	R.B.N.	RAMJEE BOLTS NUTS
201031	R.C.	R CUBE
201032	R.E	RELIABLE ENGINEERING
201033	R.E.	RAMU ENTERPRISES
201034	R.O.	RISHI OVERSEAS
201035	R.R.G.	R.R.GRAPHICS
201036	S.A.	SHOETEK AGENCIES
201037	S.A.P.L.	SUKHIA AGENCIES (P) LTD.
201157	RVE	R.V.Enterprises
201160	SLC	Splendid Leather Company
201290	EFP	ELITE FOOT PRINT
201291	CT	CONCERIA TIRRENA
201042	S.C.S.	S-COOL SYSTEMS
201043	S.C.T.C	SRI CHAKRA TRADING CORPORATION
201044	S.D.S.B.	S.D.SAH BROTHERS
201046	S.E.P.L.	SWARAJ ENGINEERS (MADRAS) PVT. LTD.
201047	S.F.H.	SANGAM FAN HOUSE
201048	S.G.	SAMS GRAPHICS
201050	S.I	SETHSONS INTERNATIONAL
201052	S.I.H	SUPREME INDUSTRIAL HEATERS
201053	S.I.L.	SAGITTARIANS INTERNATIONAL LTD
201054	S.I.L.C.	SKY IND. LTD(BR)-CHENNAI
201055	S.K.M.T.	SRI KAMATCHI MACHINE TOOLS
201056	S.O.P.L.	SAGAR OVERSEAS PRIVATE LIMITED
201057	S.P.	S.PARTHASARATHY
201058	S.P.A.	SANDRO POWER ASSOCIATES
201059	S.P.E.	S.P. ENTERPRISES
201060	S.P.L.	SHOECOMPS PRIVATE LTD
201061	S.P.P.L	SUMUGA PACKAGING PVT LTD
201062	S.P.T	S.P. TRADERS
201063	S.PA.	SHANSCO PACKAGING
201064	S.R.	SIMMCO RUBBER & PLASTIC PVT. LTD
201065	S.R.A.N.	SRI RAM ANJENEYA NOVELTY
201066	S.R.E.	SRI RAM ELECTRICALS
201067	S.S.	SRINIVASA SHOES
201068	S.S.A.P.L.	SANGHAVI SHOE ACCESSORIES PVT LTD
201069	S.S.E.S.	SRI SABARI ENGINEERING SERVICE
201070	S.S.S.C.	S.S.S.CORPORATION
201293	FG	THE FLORIDA GROUP
201072	S.T.C.	SPARESWEAR TRADING COMPANY
201074	S.V.E.	SRI VENKATESWARA ENGINEERING
201075	S.V.E.W.	S.V.ENGINEERING WORKS
201076	S.V.I.	SRI VARI INDUSTRIES
201077	S.V.P.	SREI VENKATESWARA PACKAGING
201078	S.V.T.	S.V.TRADERS
201079	S.V.T.C.C.	SRI VENKATESWARA TEXTILE COATING CO
201080	SI.E.	SIM EXPORTS
201081	SO.S.	SOUTHERN SPRINGS
201082	SR.V.I.	SRI VENKATESWARA INDUSTRIES
201083	SU.E.	SUN ENTERPRISES
201084	SU.P.	SUN PETROLEUMS
201085	T.E.W.	TANFAB ENGINEERING WORKS
201086	T.F.A.	THE FORTUNE ABRASIVES
201087	T.I.E.W.	TAMILNADU INDUSTRIES ENGINEERING WO
201088	T.I.P.L.	TEXTON (INDIA) PVT. LTD.
201089	T.L.A	TELE-LINK AUTOMATIONS
201090	T.N.T.	TAMIL NADU TRADERS
201091	T.S.I.	THE SOLAR INDIA
201092	T.T.C.	TEXTILE TAPES CORPORATION
201093	TEC	TECNOLINES
201094	TH.F.A.	THE FORTUNE ABRASVIES
201095	U.E.	UNIVERSAL ELECTRICALS
201096	U.F.S.E.L.	USHA FIRE SAFETY EQUIPMENTS(P)LTD.
201097	U.H.	UMA HARDWARES
201098	V.E.	VENUS ELECTRICALS
201099	V.S.K.E.	V.S.K.ENTERPRISES
201100	V.T.	VICRAM TOOLS
201101	W.T.I.P.L.	WILHELM TEXTILE INDIA PVT. LTD.
201102	Z.H.S.	ZAFFER HARDWARE STORE
200132	VS	Venkat Shoes Pvt Ltd
201295	OV	OVERSEAS LEATHER
201299	TI 	TATA INTERNATIONAL
201301	GLSPL III	GOOD LEATHER SHOES P.LTD
201304	G O L	GUPTA OVERSEAS LEATHER
201306	GLSPL I	GOOD LEATHER SHOES P.LTD I
201307	GLSPL II	GOOD LEATHER SHOES P.LTD II
201308	GLSPL III	GOOD LEATHER SHOES P LTD III
201309	GLSPL IV	GOOD LEATHER SHOES P. LTD IV
201321	C V	CONCERIA VIRGINIA  CHENNAI
201324	E S	EXCEL SHOES
201327	GLS-Pallavaram	Good Leather Shoes Pvt.Ltd-Pallavaram
201328	GLS Unit II	Good Leather Shoes Pvt.Ltd-Noombal
201329	GLS-Unit III	Good Leather Shoes Pvt.Ltd-Gabor
201330	GLS-Unit IV	Good Leather Shoes Pvt.Ltd-Hogl
201392	B S	BACHI SHOES
201393	IGI	IGI
201396	HOT	HOTTER
201398	DHA	DHANALAKSHMI
201548	Ka	KAMMEY
201549	OX	OXLEY
201550	BON	BONTEX
201551	RHE	RHENOFLEX (UK LTD)
201552	YKK	YKK
201553	VER	VERSATILE
201585	SLP	S L PACKAGING
201681	m a	MAHENDRA AGENCIES
201682	BI	BIAGIOLI
201705	EI	ELASTIC INDIA
201803	SO	SOLINI
201719	sls	SLS
201804	R.R.G	R R GRAPHICS
201969	Tu	TULIP
201833	PR	PRIMIGI
201834	FL	FLORIDA
201840	NSOL	M/S SOLINI
201841	SOLI	SUOLIFICIO
201944	SIE	SIEREA
201986	SL	SANG LIM
202001	D S L	Dhevi Super Leather
202009	ST	START RITE
202008	THI	TRIPLE HELISC INDUSTRIES
202036	BE	BESCHIN
202046	T L	THE LEATHER
202049	SDC	Scamosceria Del Chiampo SRL
202050	CBG SPA	Conceria Beschin Gino S.P.A
202077	D G	DIDI & GORI
202080	MO	Mondopel
\.
commit;